Import Wizard allows you to import data to a table from CSV, TXT, XML, DBF, MS Excel and ODBC. You can save your settings as a profile for setting schedule.
Note: Navicat Lite version supports to import text-based files, such as TXT, CSV and XML file.
Note: For importing ODBC, you need to install the corresponding driver.
Note: You can drag a supported file to the table pane or a database in the connection tree. Navicat will popup the import wizard. (If existing table is highlighted, Navicat will import the file to the highlighted table, otherwise, import the file to a new table.)
To open the import wizard (see Table Viewer for details)- Setting Import File Format
- Setting Source File Paths and Encoding
- Setting Format Options
- Setting Additional Options
- Setting Target Tables
- Adjusting Field Structures and Mapping Fields
- Selecting Import Mode
- Saving and Confirming Import
To run a saved import profile from the command line
- Create and save the import profile.
- In terminal, type the command (see Command for details)
See also:
Execute SQL File
Export Wizard